Release 10.1A: OpenEdge Data Management:
SQL Development

Configuring Windows clients

Windows clients are configured by using the ODBC Administrator, a Microsoft utility. Use this utility to configure the Windows client, establish a new data source for the client, and connect to that data source. OpenEdge installs the ODBC Driver Manager and associated ODBC Data Source Administrator if it was not already installed on your system.

Adding a new data source

The following procedure establishes a new data source for the Windows client.

To configure the ODBC client:

From the Windows Start menu, choose Settings Control Panel Administrative Tools. The Administrative Tools dialog box appears.
Double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box appears.
Click Add to display a list of installed drivers. The Create New Data Source dialog box appears.
Highlight the DataDirect 5.1 32-BIT OpenEdge SQL v10.1A driver, then click Finish. The ODBC Progress OpenEdge Driver Setup dialog box appears.
Specify values for the following:
Data Source Name — Identifies the data source configuration name. For example, Accounting.
Description — An optional long description of the data source name. For example, My Accounting Database.
Host Name — The name of the system where the database or database broker is located.
Port Number — The system port number setup for the database listener process.
Database Name — The name of the database to which you want to connect by default.
User ID — The default logon ID (user name) used to connect to your OpenEdge database. Your ODBC application can override this value or you can override it in the Logon dialog box or connection string.
From the ODBC Progress OpenEdge Driver Setup dialog box, click the Advanced tab.
Specify values for the following:
Default Isolation Level — Specifies the default isolation level for concurrent transactions. Choose from the following values: READ COMMITTED, READ UNCOMMITTED, REPEATABLE READ, and SERIALIZABLE. REPEATABLE READ is the default.

The DefaultIsolationLevel setting requires careful consideration. A transaction’s isolation level will influence the type of record locks that are applied to records read from the database. The default value for this setting is REPEATABLE READ, unless you specify another setting during configuration. This will instruct the server to apply record SHARE locks, at a minimum, for the duration of a transaction to records read from the database. For most query tools, it is appropriate to set a default level of READ COMMITTED. The default isolation level setting can and will be overridden by applications.

See Chapter 8, "Data Control Language and Transaction Behavior," for an explanation of the SET TRANSACTION ISOLATION LEVEL command.

Fetch Array Size — The number of rows the driver retrieves when fetching from the server. This is not the number of rows given to the user. The default is 50.
Enable Timestamp with Time Zone — Select this check box to expose timestamps with time zones to the application. By default, the check box is selected.

When selected, the format is: YYYY-MM-DD HH:MM:SS.SSS+HH:MM.

The equivalent connection string attribute is EnableTimestampWithTimezone.

Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box.
If the driver can connect, it releases the connection and displays a connection established message.